SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249742 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249742 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587961,1045925,92617,166427,288282,234535,575645,543621,335028,497901,447841,455444,884498,354863,175755,960943,594385,474908,405334,92408,147609,266793,480726,820383,525572,568009,642182,612281,290868,14114,706071,689470,406767,608682,987254,23106,352372,914516,177984,304672,633564,829712,614991,97228,585218,478844,793515,883445,505073,222641,474398,613846,514460,160004,443600,567948,343393,815915,712308,1033819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]