SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49650 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49650 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104415,610036,439423,524988,994229,615590,495059,243649,944240,841819,718999,466115,252805,673050,109221,819613,327386,484052,799406,206476,301011,540275,297038,703226,147996,171218,817265,492107,216869,719227,915904,1027870,895617,967559,260911,546771,1021921,301501,484940,512244,92144,930095,536396,1007019,459990,13081,523756,942755,810927,774777,914558,818314,242646,829050,83461,348555,89847,104521,883407,636284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]