SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568376 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568376 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321275,153496,898639,859250,424214,408924,433366,309571,604037,138220,174806,519415,981157,388415,984499,1019832,496424,670188,54925,180815,261315,620288,722733,634455,406713,352000,750319,852735,847767,831099,567520,526554,1000684,50004,527654,879247,141036,392097,916835,416910,511111,1031199,3094,5215,192006,952393,399183,125641,881680,421921,339833,339669,1006260,738719,824535,741470,1017214,1042399,739249,146942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003900s ]