SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489911 LIMIT 1 [ RunTime:0.001001s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489911 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52797,402912,500720,762861,617307,465580,360483,84257,128699,847393,500946,374640,783542,279334,869986,274175,251269,734684,1042106,955743,418679,611264,631858,503389,1007163,578395,924016,820953,90396,810854,711247,180573,224480,518125,496650,691258,302181,932638,258313,543050,44233,560296,601705,34711,881214,569028,442701,141634,311004,174168,919843,967123,752926,185134,512998,589240,5493,527574,384541,932581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000973s ]