SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415225 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415225 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216316,882720,476824,433210,166402,216411,869937,459634,336930,829477,926601,866915,544682,844837,125907,47002,675517,896568,294758,363208,411580,634254,409020,953972,75619,636698,1048187,14910,293737,1039242,878653,14571,266953,199301,477900,635728,431481,738638,479605,425008,850698,455499,334997,810840,785757,207281,110267,784249,997055,424986,565371,597369,189245,15270,785014,113689,481254,636983,66085,590946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]