SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439711 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439711 [ RunTime:0.003258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643784,66945,220183,403937,181502,596724,888743,217323,795193,549427,161806,566370,649264,808467,679517,184236,591442,533838,451281,218313,45759,736310,703443,891312,1011479,1040837,272528,487707,569130,954093,748836,582235,1032438,824890,1034524,241755,501585,287855,161164,728157,514797,698623,1018450,32392,419086,879254,41043,950641,255085,208866,392035,637597,366373,400010,178557,991639,863122,700357,549405,606959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]