SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351272 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351272 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786596,173460,572941,997424,940140,900410,49487,623326,215308,93120,537320,572430,608036,416502,256675,688173,63506,286278,479812,368144,701941,111372,272326,478592,690049,518577,472263,911469,470168,18300,75486,245251,28985,6718,992353,561814,609338,754241,1039536,546158,34890,350848,216178,807781,515052,366879,951515,913003,546156,695377,275014,957044,629528,418910,399046,353850,565877,974914,215712,997893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]