SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039612 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039612 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261013,611600,667034,26167,642365,482202,117752,525823,1039250,1014718,802294,254146,715926,939967,67067,106632,383163,886362,992645,1035842,809695,460281,350133,755324,846429,868416,1033230,325350,127357,669053,440587,871257,464831,782084,197262,361351,339921,773217,668694,1014747,661481,926475,584944,648795,325634,175214,850871,583035,556163,297176,178448,228929,355084,850258,405042,835884,770018,438954,933043,823964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]