SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047523 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047523 [ RunTime:0.003206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689402,613816,854179,662577,127083,972401,525194,338068,325994,673391,149855,914708,59522,484149,257418,396193,357171,270103,552514,274133,285095,783981,353345,818825,107635,234005,174518,176301,371207,11915,644042,26448,333961,350827,928581,659994,210648,323773,777811,895353,453890,860652,479965,274702,652534,974380,628427,1047607,816211,765733,191536,236165,321476,81756,488503,255774,618181,504360,191884,637502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004481s ]