SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508510 LIMIT 1 [ RunTime:0.002323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508510 [ RunTime:0.004355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945223,404497,391711,1033091,682693,233889,193217,75597,188325,420624,510317,617400,68829,419791,1001011,133141,33093,508982,663112,577337,339383,315024,633009,402044,424399,138495,997516,606180,952305,679350,108180,254284,987467,609089,730824,662511,421057,391819,606921,648869,366633,462900,888394,973238,859114,344632,924372,78289,591087,360142,724912,60649,518043,882257,1020214,436463,851419,840613,900290,778745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008157s ]