SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543617 LIMIT 1 [ RunTime:0.001742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543617 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325520,574054,221122,51536,308075,728734,318297,636764,850801,132114,286778,697758,1035592,423061,945926,41143,1023622,806715,906005,822941,1000266,18443,378708,934866,160270,644688,465915,951471,993294,106260,484538,352775,79720,34997,20040,629256,1030066,1033463,673679,628921,21262,735482,808784,340786,777442,331814,593838,708456,558741,637562,902521,406066,428751,616103,164058,644613,83567,23386,138397,671608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]