SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502585 LIMIT 1 [ RunTime:0.001107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502585 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552630,422454,675088,931294,247032,465219,57197,816802,176227,250681,580369,733193,142668,269536,755565,710629,1008159,991623,744143,282503,992190,683618,548384,641934,423192,869685,52606,488669,160093,868698,424779,590928,258455,906317,544285,423959,400032,600128,356187,681965,700782,146306,505288,481739,824708,377278,432183,134226,593277,177380,591251,1012795,72876,926025,925131,156778,671450,98210,819709,255089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]