SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310104 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310104 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166271,613901,793624,47687,880903,652707,726838,526744,917235,605787,850124,278795,437367,22513,34889,696134,649917,727171,905230,832279,19436,232495,2236,641844,49452,603426,84097,173408,344447,401195,705688,955462,789450,704631,448458,195349,199542,996607,42215,617486,71798,376904,380560,42861,127393,299181,602931,556883,815345,527399,712222,859375,335230,769068,972336,864329,333483,16754,660045,699145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]