SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017407 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017407 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723137,1024351,429977,325683,399708,371580,530601,974093,10153,717148,437930,608669,546031,575003,956742,353981,951415,86637,952061,105652,171453,596009,523834,934773,658376,466561,601803,163878,653763,424950,920203,80141,69317,92729,955111,38533,546464,173467,930055,341822,456630,270114,156581,672772,757625,78133,575853,902967,477845,873519,844405,28080,573509,224926,512994,83041,445998,527759,257352,515784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]