SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505683 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505683 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761827,744914,973287,468062,514976,49012,418870,388,173003,612945,575878,939565,770184,923425,53161,985870,716099,985923,668873,333004,467875,325813,814939,550231,838228,706913,525628,748193,518914,63344,247312,345175,617199,79158,832063,832174,590171,564487,108818,385860,368853,505759,608099,1000583,191410,538180,688737,992614,299662,232089,672297,777090,280508,757271,1048308,134275,1034079,198789,565019,791151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]