SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620054 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620054 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985363,1020217,33280,377905,848401,1017719,1046644,352390,360579,599231,155561,588566,754626,481326,119886,703515,154490,243793,389644,971739,233510,386448,433474,344111,498657,924426,932773,447832,95807,1027562,662670,183912,216158,450526,927005,847996,703976,15604,963846,66376,437562,479501,241872,119779,440641,1012447,244060,174580,336311,260558,710279,266310,339677,813438,272164,1374,440769,565361,357082,1021269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]