SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505614 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505614 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290066,81365,254746,867246,911619,626033,766374,376324,295701,656586,147618,383051,234577,45138,701164,784941,428891,604733,814398,675307,608254,210577,363956,764812,630791,210889,811844,892096,560034,767540,372878,907182,49869,30427,169843,1017364,474711,889396,617055,705759,730480,358458,764122,808881,486225,339077,399790,525316,958976,622066,631021,804343,944133,330398,142120,178188,460450,652644,362653,143024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]