SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038599 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038599 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932810,141092,506163,120836,282344,1034530,280070,8563,109056,305056,326691,175148,1048433,416101,1036556,311802,164811,34803,745687,816545,432349,671290,568121,820522,339254,652509,167256,448526,732008,368390,545436,534332,527207,599695,372203,328660,988560,533240,1014435,998633,672269,711902,156205,619631,914226,1017477,271876,613124,264877,954020,1018892,391469,535099,486009,727863,585695,614201,451000,511685,165643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]