SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509060 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509060 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208515,598310,354634,360187,47707,4003,476938,851993,54885,368843,332117,362847,691244,574766,454614,580508,135694,118636,864019,611919,543832,555833,683495,51883,515724,249490,400698,656829,878705,650334,58856,19396,669634,998230,197238,180240,671774,66036,151299,444359,531037,569529,224157,447944,765416,784134,18839,996545,881984,412093,28946,468570,523843,1024593,1034025,581967,853799,835941,803502,261956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002147s ]