SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333601 LIMIT 1 [ RunTime:0.002605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333601 [ RunTime:0.005065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816179,1010558,992696,807588,295330,86485,410219,775142,756758,218544,755494,350461,1039049,83187,828740,1043746,270881,331738,627040,547721,559446,642921,923001,100890,720837,204457,322183,196712,251655,652272,43215,143514,330342,782472,224941,420079,668776,458380,43644,150950,363635,801645,346428,819556,947189,88925,309121,1009916,316996,573442,546138,118827,13390,675194,634306,526044,316360,203968,712294,882767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002580s ]