SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410939 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410939 [ RunTime:0.002824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895973,224222,246373,1027996,977135,233159,275886,672540,956598,464215,426303,340899,248199,210799,921325,127336,530016,418314,241373,223948,502593,60215,1024436,268022,972628,873263,268830,295379,116940,579382,253149,844472,271454,16184,573098,407068,820693,472152,792077,323564,751285,757274,511098,824309,466613,206559,561945,282926,243808,879376,577932,594161,286412,685282,782293,287965,777022,344308,183351,1039862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001285s ]