SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006455 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006455 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641997,1024697,996777,722039,537564,1258,524819,388776,117985,593335,920282,250941,675457,1005270,188041,385412,296074,105582,1048115,269053,313549,832082,206869,119725,310776,362133,194617,1035836,1023612,363864,63538,52524,653836,1002078,239615,709342,607621,263587,380545,463285,973760,277466,1002607,979904,951165,826033,360932,845459,852604,810521,758462,131446,7802,551869,1039187,419560,739066,680517,708231,871346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]