SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018935 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018935 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584265,694858,372075,581491,1042812,561449,199650,695324,967614,931278,937291,124468,831620,530340,21269,1004676,531698,249742,113061,1020100,119007,1021301,782324,753504,612580,392353,485164,771408,579987,61561,143253,1018079,375258,716369,826792,739769,562649,581758,752566,601542,12257,561755,1007945,1021134,593908,771170,783550,87190,947258,1003615,917178,834404,864392,446426,277158,523473,244419,371871,909609,765064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]