SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506079 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506079 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729709,328040,787554,185477,292929,1038163,220375,891973,912824,188769,384364,749629,877595,160078,598246,306095,1036663,1026180,94567,1043972,650505,757435,239350,84084,142393,993212,838354,703662,779714,211438,763770,169957,896868,852746,482290,858573,484432,334207,696082,283904,198638,115579,863705,912399,949686,74210,1013344,155317,958968,585536,648705,687781,244002,548161,134132,514791,618320,842589,995204,167214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]