SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016868 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016868 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764638,25357,269562,443432,128439,622915,628457,315255,134200,699007,697045,608634,518843,54690,940695,796247,249505,378706,82703,215018,68527,387320,364105,594193,970452,152015,167943,564708,390779,36138,984028,520049,182346,695018,462078,229143,174387,365443,761379,204970,120073,830888,557718,888982,266698,265931,220326,852289,281037,707786,402190,96354,54613,880866,1003911,694811,212509,612329,345446,776881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]