SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505217 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505217 [ RunTime:0.004483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185381,468774,614073,683202,328067,803953,455900,459658,1048051,617432,517230,249125,363192,213035,784071,271246,520047,252490,993529,689961,667613,826498,464100,908112,401449,611759,493399,138175,716726,11156,942218,961802,226422,392412,1018283,988536,260526,820641,784631,955290,904474,963758,836640,733180,859313,519445,8186,618406,45209,530733,337648,240694,137575,917758,204519,27750,780994,119388,783916,251214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003849s ]