SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422972 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422972 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562662,360046,496860,528556,162701,9198,665664,869495,94000,108299,1041649,50162,878331,860188,300064,362923,439973,677621,38709,254686,650521,211974,433861,486026,426889,407280,105302,791685,126694,131075,312665,161451,866153,368227,282493,112953,23403,986119,13871,38662,374607,747893,675993,125643,235451,483077,404905,859768,876786,580672,198291,770141,309792,481214,888330,28200,557133,603851,851731,439309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]