SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531063 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531063 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862267,301517,695467,993788,497236,688008,285365,24692,1034751,905326,564930,697917,114016,64131,352619,791815,130070,929121,232000,117917,679763,153873,528004,588668,444298,369262,416513,305190,319346,617028,545207,534745,816054,915924,252241,1048556,754496,155576,690822,89284,434751,986559,742282,557304,756241,34901,279937,1034867,771751,400176,410387,311818,9146,461351,695292,515396,612226,551222,256423,118744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]