SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801008 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801008 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311250,998482,830128,714132,279723,667213,630369,687048,992525,802124,195913,959630,120287,290858,977792,301954,364501,7164,638588,303540,597030,2642,340311,931005,240979,629676,825702,64642,621523,252776,481749,806993,915465,921345,346650,426762,166255,697061,226670,919218,819302,527144,235569,599572,63453,648265,157941,738083,260304,383010,765477,847032,233326,106361,399544,677470,317036,713429,104916,649168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]