SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017731 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017731 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146719,731599,981042,756363,705133,74418,111167,314935,989400,1001080,338858,292868,406851,985121,819935,137559,747184,21866,220596,763001,400132,24367,975765,392931,56590,900920,317699,1042705,536513,239898,616871,134999,2356,404937,284826,356085,659832,232979,564848,129234,871766,821692,921128,280667,648131,848640,576755,192022,942625,207597,984534,937984,716073,161258,116764,377149,788437,591787,805144,870285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]