SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002773s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800642 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800642 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525107,1019968,746943,220003,951692,849856,69113,947744,101983,447886,855664,74590,299256,993428,1022946,1038912,794372,366898,186390,251777,697115,321619,269163,730536,488497,923743,405131,427325,483968,820857,830356,200300,805330,936233,1029202,271460,25762,86897,351161,300787,480180,908064,167934,896421,140718,923960,607107,456750,829906,329200,126290,272106,566559,345842,513581,393813,782000,927416,701681,976404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]