SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477043 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477043 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037500,916339,470059,967202,576150,1023787,1046617,893212,240543,790691,888049,215866,419112,71429,921852,555926,636553,1045955,388774,227871,469031,651217,625904,1018643,625280,1000332,739239,129833,618551,307510,825173,542529,180265,279392,812481,535842,305424,402607,556736,23164,316284,499941,823473,33140,723159,262004,673345,934412,666919,96729,378413,559587,176916,536700,63280,837715,867802,215431,613158,304803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]