SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180189 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180189 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301526,68225,356731,1012271,425010,680601,504612,792450,741342,803524,254395,332840,991841,486907,348476,993181,927781,889343,434252,174198,702983,706084,594481,721811,956537,302041,233741,43646,655760,915262,530093,254407,729009,654708,136243,803250,833613,156273,709639,6010,60483,132303,689443,356907,993941,188770,432706,625899,36140,144074,158741,961464,639466,307805,227687,958956,990679,571757,131704,290556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]