SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291935 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291935 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54470,922947,428480,541319,751491,819816,87237,769219,63594,528797,979447,868390,73947,242182,387205,530309,499489,394706,680568,706491,51475,707656,756715,508878,155354,997591,501763,696120,261085,518246,560048,349103,1042914,1016563,290368,901388,83981,128412,613928,925800,234644,788439,739581,275866,566855,550336,60567,709701,481414,864675,511373,687064,148591,212790,56998,896325,995520,1044703,461881,67026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]