SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586957 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586957 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781475,805797,1033506,607809,280247,577648,756837,417491,3372,331637,229084,601714,690616,160153,470232,26464,130839,1045369,358340,473883,863720,905213,207678,301038,551185,675109,983697,130976,218958,602895,79143,652998,504418,905632,704861,758365,738019,243590,669089,751446,772470,317162,973304,58068,949255,486121,491923,618928,710242,204833,727156,328618,523753,232786,925252,358550,441614,462256,959157,824912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]