SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812911 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812911 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812703,508804,1034856,25623,147827,252053,789530,791424,268055,952151,18714,614113,689676,614221,629704,300671,733288,773159,515891,303383,1034352,468270,492947,1007728,283867,249172,302652,608435,473498,262666,314561,100675,627298,212904,405901,895137,769885,839352,689851,895850,776497,108507,201763,90366,596073,193269,636215,755942,71675,638957,924680,639671,691698,410742,390127,946932,525186,55240,473010,131857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]