SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543052 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543052 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604251,368572,1009003,225482,1653,111133,805919,363482,659070,807774,303023,761841,248370,968915,82978,918179,324273,732901,134461,381726,911790,873623,858718,1023307,377911,674278,152209,632978,288976,843066,1008325,415507,145476,521873,271308,901180,181320,398149,60436,661743,239543,845071,62647,184862,327669,450782,317719,961356,92416,493741,945141,137697,853826,783232,1019384,269674,17795,458572,990527,809135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]