SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51191 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51191 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166848,875910,466116,24387,32315,161567,173850,822786,66305,167619,76079,220343,868254,504639,406754,659616,109612,553861,503614,473512,253526,204690,973960,83249,735637,790067,560834,1023709,413199,1036796,186044,764315,375939,691978,1006484,118435,716947,125014,239356,260218,136379,570374,991322,998828,417583,578977,329221,474082,423016,257128,201676,643467,840710,562809,674168,926330,258637,21344,330230,703970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]