SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 79203 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 79203 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743812,691935,609066,356170,422110,146602,107964,1011916,97929,726439,242529,490484,486919,1047949,819584,114725,680387,24565,742601,391242,155392,539100,998149,627481,352170,60873,691145,662286,728802,786762,455917,579018,589669,695850,365231,813798,261176,495920,287008,915095,776088,543832,1000393,1002831,1019912,285057,376871,787117,559036,796728,641257,29175,999420,364254,303370,104460,131974,462500,607445,531083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 79203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 79203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001814s ]