SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481230 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481230 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286959,1046746,994103,192553,1047480,908285,647156,724659,920357,95286,884027,1005210,798978,833636,556504,749434,488723,361578,143647,348738,783549,537341,927399,440124,450657,262261,575344,1006612,929762,196988,415057,1012339,958118,69960,732736,266255,526249,442636,616241,1011134,471158,305840,36420,951167,320800,481660,741981,697628,301986,453031,161806,216991,138150,53146,131797,442255,236673,621331,688340,354038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]