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` = 296501 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296501 [ RunTime:0.003150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932711,144694,764091,831301,40201,70670,441185,829454,744666,605102,455209,834149,52697,98877,242407,153891,754873,326584,929307,772781,948646,48004,834886,191752,371791,133744,858683,1033646,968579,853471,1733,534532,33283,858965,695484,324815,110241,161128,962628,741514,203835,859747,753776,970571,146890,823750,2457,835591,216772,5605,725839,757046,811593,661319,646724,152249,745292,204951,728412,107372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002264s ]