SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14318 LIMIT 1 [ RunTime:0.001095s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14318 [ RunTime:0.003746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168244,828924,513385,935891,1003439,193212,951701,650941,872845,591221,762521,215125,744239,242665,515209,44279,221455,715498,952273,334115,393258,166570,991551,685502,523677,683210,518695,508576,561405,966013,636020,695388,700469,705579,840712,1028430,520187,893985,307216,720110,271406,922999,234027,249983,617560,908529,812050,215862,353568,40595,992709,192285,782139,124254,405469,35041,736895,155117,250663,868268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]