SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503907 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503907 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567258,785011,244475,405256,693447,686647,744081,794396,241730,762150,243548,779556,861463,816569,223439,915638,1001969,594057,483169,358123,426480,179893,727362,515388,18539,870489,1003371,784635,26502,335683,135787,626715,759314,807371,476435,672513,646033,548955,889890,797641,924116,867102,669122,737692,733836,700380,654973,117807,135642,414488,596495,1035649,639436,381346,458661,322347,362649,382955,878498,541167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]