SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49090 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49090 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936359,592496,731566,417081,772368,469172,796795,897477,266463,1036180,380256,348310,998960,425461,961195,542466,212746,273212,1012542,862617,831781,15380,889966,45643,170818,730379,96271,12226,988917,662634,795736,970417,217588,1040333,525483,230352,984307,41705,62222,1008405,875913,681111,606548,331010,280153,158392,949108,204791,214522,65063,974334,649979,380224,128065,310721,317922,63653,1352,120447,87947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]