SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53670 LIMIT 1 [ RunTime:0.002559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53670 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164074,995124,463301,589402,522717,106979,872879,26024,168188,339573,192799,879032,91954,50879,1043591,685759,298221,13581,476857,938083,639322,494796,404202,590887,26560,497841,119789,694019,76910,858516,951240,492604,437383,554413,543206,197715,229955,23097,705618,634012,170011,648843,393803,680313,399872,386659,103268,650078,438389,739104,787544,641946,564684,1001940,1023084,250593,412864,553202,1003853,1044198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003018s ]