SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670583 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670583 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368104,1003729,294490,592151,515627,497088,189084,1001412,444907,753396,588701,198529,728304,309570,246397,939970,975523,335115,378977,125033,77568,206314,169473,731583,162226,846051,425504,159695,55569,950507,533538,494871,411351,998907,924073,592149,219086,543104,586751,70309,63089,302329,315190,301257,828282,657918,28908,180978,963703,611998,557204,657314,461969,819208,393456,82773,663635,424434,1041780,519433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]