SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411440 LIMIT 1 [ RunTime:0.002534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411440 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839385,709547,602953,823836,376772,556122,64161,1006302,384399,339738,783374,663609,1015395,772921,579645,14487,623431,18608,160978,86386,966006,930687,957527,168038,913212,942433,552622,670214,789469,272195,465995,818258,771234,1002859,474600,1018326,5806,302950,807743,20519,267328,791110,929870,775458,534266,871947,103312,96756,208069,665149,161194,28181,52008,760212,135793,566988,1030317,1028903,874199,152065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002055s ]