SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417706 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417706 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819294,1034287,717679,962634,355320,786257,302555,762168,503017,979878,800013,998164,6190,829442,46041,282700,663779,340704,2382,504240,36239,627405,1016561,444373,505774,860045,159928,1039987,955241,155096,696590,572614,146218,92836,198137,50511,449681,984604,498197,823969,305171,217477,222595,486338,896905,842856,1046911,680795,179067,145611,955065,408437,949492,466660,582377,994989,626052,912480,200941,240435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]