SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518974 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518974 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456210,528399,983148,369655,403986,417793,9623,865316,435572,466680,861130,502909,1001186,104948,1008875,559165,8837,905995,837810,464090,378686,299798,164216,368989,327859,867409,816530,449620,825237,852204,354261,868234,178721,135023,70853,934324,982620,1024102,779549,421092,1041858,957093,128006,136743,114789,453577,623373,197854,477987,751050,694002,549051,498765,1026147,385314,929468,763212,299386,938946,554587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]