SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149915 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149915 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036187,993258,224013,448266,907129,73502,378894,175406,146974,107170,114754,77484,299411,188622,630490,903425,169134,661678,1044797,367725,958231,473581,1016136,1012530,922948,293632,426731,724920,735168,161750,392651,688437,637267,289364,116071,824244,683798,102825,403018,338849,157827,195631,78821,479653,428991,724258,773349,461319,370843,304647,601714,366391,454018,433375,888756,58109,13475,729978,705136,962690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]