SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368082 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368082 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465416,414182,67899,633194,280281,555299,542800,367609,250513,18541,823937,964702,1018852,426238,998796,757207,696073,100060,631000,476264,852081,795766,119000,494473,590430,502104,1009773,514790,1006743,848114,455912,924448,517610,347097,1001012,962652,905390,973388,52476,564771,659672,667052,959815,951412,772259,916479,755408,336706,221420,208060,957521,926383,926583,650297,1038172,147813,178221,908117,818794,65802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]