SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563944 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563944 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234971,203052,479567,29363,64824,442031,35382,469787,750494,1045178,921031,721179,397292,885787,239329,571337,852463,370962,990230,270613,1009830,793749,411939,50073,735871,66681,1009350,1021536,442378,489318,904042,522723,198231,416373,777727,831582,968172,986004,355560,814652,1028293,520829,1048199,282375,811,212988,678334,499242,240953,662342,638958,612555,106174,674699,1024036,885087,275680,122408,913279,472302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]