SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409787 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409787 [ RunTime:0.005475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430599,311763,700530,647049,296445,85406,32016,531776,1026216,119988,634922,173128,467690,941393,609991,73786,903467,899038,458677,518358,569269,899618,390384,35678,562241,112642,168186,956074,454737,427886,961775,920054,659127,512880,571040,742005,603847,12030,692738,107076,882872,382401,878444,447030,527716,139277,837049,448591,161087,1033788,888580,550010,918705,297832,971545,251188,334664,18237,728174,327487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]