SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173004 LIMIT 1 [ RunTime:0.000842s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173004 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378994,454039,488264,314051,574874,666365,603478,1018541,75740,308055,961576,17610,427278,606303,353142,159244,678864,778805,988985,624840,749311,420076,397939,101981,923117,188690,566217,331720,546932,355848,727462,683724,271157,733733,398360,705092,467327,752192,516759,1019602,504606,937881,134484,567103,774175,1010802,483008,151829,751783,755282,818576,174239,917438,1038808,1020575,770015,788568,203856,873884,1039899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]