SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39981 LIMIT 1 [ RunTime:0.002410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39981 [ RunTime:0.002670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356237,265886,855580,741725,1021830,740149,213801,4314,876681,168098,400950,622476,811385,915991,20725,468180,862577,1037430,868607,543175,412880,933166,37652,321340,760376,1042058,45651,271382,395006,972541,510175,32367,945818,781156,45480,578006,651518,324156,1008292,306864,758134,641654,501279,202674,555019,1033744,634811,179529,405049,19720,77418,770599,494729,1009169,111231,679430,914367,288896,566703,874524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]