SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413200 LIMIT 1 [ RunTime:0.002812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413200 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285058,923627,929924,496852,829432,951638,340623,192712,79200,554844,812221,656554,1048266,932611,207054,4141,229417,975597,764034,606508,245957,237873,414771,28443,405605,710300,907129,974691,549813,466839,256525,695315,783432,123497,587149,279490,1044240,502877,695853,843439,222680,1012418,320012,1003516,460641,774766,294100,824152,945295,590436,439765,435144,656568,1020807,378837,77981,744544,877286,75207,536401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]