SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483703 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483703 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310233,1038408,189305,492296,442272,735581,564786,996013,937221,208239,477846,600440,311838,931078,1036943,612811,137889,870329,936999,453384,521916,862772,318221,373836,865084,802000,1004524,1011579,430508,626383,996339,1007913,490053,587026,1007028,424487,63985,606512,101089,440943,1002544,214400,820943,546391,205366,123463,333092,1944,585375,933140,538238,163213,196702,318148,1044857,652394,114920,105822,674805,385312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]