SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516926 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516926 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138185,694326,672599,685336,35753,686722,678197,616821,1021716,556903,677895,592115,545116,874511,193865,812813,498105,949747,187774,207945,834757,95653,286770,676300,857397,930842,230812,1006274,835752,406607,248258,968417,977028,278358,979689,1005097,1024667,304924,955590,60777,196418,232149,598854,221101,12719,724062,76229,127709,972699,61123,460131,111395,873790,679185,760682,951746,823341,30956,665195,683547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]