SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503135 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503135 [ RunTime:0.002964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401164,869540,560801,750335,829437,272978,707329,882996,868914,330576,795735,712334,149185,756622,708548,885621,251873,667496,232920,144888,205448,118403,605014,20186,647045,774128,6340,817382,574376,325792,481870,196579,228885,411734,403644,923405,889668,261592,321586,54705,920049,783117,660711,339489,977294,234028,100924,151460,283162,283689,603817,622344,370467,599118,964770,787229,903973,951779,1030314,961111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]