SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106618 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106618 [ RunTime:0.003671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017425,634526,290813,485145,303462,90493,779315,58042,548350,575010,911133,1031282,881442,25684,426015,219108,353186,629862,1013700,867482,872796,162077,38645,463215,716283,971505,938597,783724,506366,325216,942797,246781,894745,566010,574738,350980,893501,429357,1030155,405586,623649,551033,809977,330069,301456,802683,378800,79764,227194,373287,767206,1002738,772863,901635,362085,580073,318574,490820,103396,1003379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]