SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002889s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262711 LIMIT 1 [ RunTime:0.000980s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262711 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530570,194368,40207,118238,232089,483283,364711,489191,378166,1030855,140996,329434,903676,325311,131037,775588,335464,441858,419259,222218,759569,384899,1038233,8210,906560,603934,941974,181792,436341,605832,306245,94700,664657,628846,277999,600484,485960,542051,444669,586678,280641,216410,814605,930846,409410,824508,882962,510746,1018973,929314,575159,778388,71417,883477,830084,986808,63485,941867,661985,742070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]