SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001968s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142611 LIMIT 1 [ RunTime:0.001065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142611 [ RunTime:0.003272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15778,555775,988557,191427,145599,64612,616870,1036090,359736,15924,1021187,282733,993758,969928,393960,537877,473641,11109,526839,601807,734579,211101,583855,573023,1002163,629540,548779,688757,306699,789450,596345,366955,316871,823607,854965,527291,993310,476761,473130,482493,758231,348039,1014016,6263,332891,65856,488716,344327,987551,685247,987533,427412,228351,99581,776162,351466,254475,766555,441625,14947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]