SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568213 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568213 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44996,477611,234673,728001,582942,589765,832126,864305,872054,289992,266321,517368,1001628,689314,1006633,358973,327093,851802,689581,34517,258073,651292,1025491,880490,14363,480653,968295,872881,509703,208477,807941,87652,230088,112279,830180,797658,787564,704319,939888,341810,1027435,131038,648459,775706,954551,996206,712587,162821,185646,1033914,972153,624424,641517,489690,754906,568157,403604,237507,612709,6166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]