SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419386 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419386 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733994,718461,804519,35537,265016,1011726,245336,754419,654893,629830,431234,368628,877409,615526,359100,1036635,553578,928652,59726,3787,540507,288126,355974,481124,355097,146991,502012,225436,796807,510449,160182,76989,377589,936988,554255,962088,299469,410565,21575,335788,322150,173871,159918,257555,603589,220692,417109,671866,643055,739409,763762,925916,195187,16584,504320,1013352,741895,794884,825353,789762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419386 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419386 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]