SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399883 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399883 [ RunTime:0.003442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213342,765980,661855,208318,747542,627835,154870,247929,315179,167610,72707,962037,545638,250840,404903,129265,14111,168562,740119,819912,361434,636020,684036,169396,1008365,845213,916368,469448,730818,248801,121644,795986,301275,978082,838026,481446,670261,942121,603386,877213,559472,258141,774003,632097,802561,575371,322488,569387,386885,22621,771398,1014784,885615,839083,351359,503060,868053,576051,71789,1048612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]