SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343960 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343960 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153230,601030,238541,416299,260689,467433,461739,312035,634109,63923,702197,545347,920719,808431,211544,961919,809473,74192,565741,250572,120690,381407,437338,40203,269767,999650,777411,719192,9901,691283,803950,835772,923838,929866,815577,852139,962043,23975,456959,309267,198481,323580,138759,202764,212622,8307,458817,228973,65839,400814,48356,361818,19863,114106,373078,9144,725194,205950,443361,843469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]