SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002417 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002417 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533089,952959,197168,266127,912639,901729,536908,501802,894178,1047907,413764,557799,861480,112619,841423,1020674,9933,987427,27113,902639,357845,697977,29519,489800,713822,146568,629802,793260,897356,929410,835173,254916,694875,104341,868726,144891,987149,963358,550188,131173,130687,453729,379668,798523,773776,398051,939135,660934,560300,662657,915123,175705,242429,338354,641594,249845,849391,286059,1023104,356040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]